Database Triggers

A database trigger is a DDL trigger to the current database. DDL triggers execute in response to a variety of data definition language (DDL) events. These events primarily correspond to Transact-SQL CREATE, ALTER, and DROP statements, and certain system stored procedures that perform DDL-like operations.

Note: Support from SQL Server 2005 or later and SQL Azure.

Just simply click -> Database Trigger to open an object pane for Database Trigger. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected database trigger.

Create Database Trigger

To create a new database trigger

To create a new database trigger with modification as one of the existing database trigger

Edit Database Trigger

To edit the existing database trigger(manage its general etc)

Maintain Database Trigger

To maintain a database trigger

Delete Database Trigger

To delete a database trigger

Achieve Database Trigger Information

To achieve a database trigger information